<? 
// Selection des Officiers de la guilde.
//$offSQLArray=$sql->request("SELECT `g_title`, `g_id` FROM `ibf_groups` WHERE `g_title` LIKE '[Co-GM]' OR `g_title` LIKE '[Administrateur]' OR `g_title` LIKE '[Officier]%'");
$offSQLArray=$sql->request("SELECT `g_title`, `g_id` FROM `ibf_groups` WHERE `g_id` IN ( 4, 55, 56)");
//$offGroupId = "4,";
$offGroupId = "";
foreach($offSQLArray as $staffSQL){
	$offGroupId .= $staffSQL->g_id.',';
}
$offGroupId=substr($offGroupId,0,-1);
$data_staffs[1]['title'] = "officiers";
$data_staffs[1]['mgroup'] = $offGroupId;

// Selection des membres du staff 
//$staffSQLArray=$sql->request("SELECT `g_title`, `g_id` FROM `ibf_groups` WHERE `g_title` LIKE '%[Staff]%'");
$staffSQLArray=$sql->request("SELECT `g_title`, `g_id` FROM `ibf_groups` WHERE `g_id` IN ( 37, 51, 52, 53, 54, 58)");
//$staffGroupId = "37,";
$staffGroupId = "";
foreach($staffSQLArray as $staffSQL){
	$staffGroupId .= $staffSQL->g_id.',';
}
$staffGroupId=substr($staffGroupId,0,-1);
$data_staffs[2]['title'] = "staff";
$data_staffs[2]['mgroup'] = $staffGroupId;
